# -*- coding: utf-8 -*-
from sqlalchemy import Column, Integer, DateTime, String, func
import datetime
from utils.work_db import Base


class UserDeliverStatus(Base):
    __tablename__ = 'user_deliver_status'
    deliver_id = Column(Integer, primary_key=True, autoincrement=True)
    user_id = Column(Integer)
    # user_name = Column(String)
    resume_id = Column(Integer)
    # resume_name = Column(String)
    job_id = Column(Integer)
    # job_name = Column(String)
    company_id = Column(Integer)
    # company_name = Column(String)
    deliver_date = Column(DateTime)
    reject_date = Column(DateTime)
    read_date = Column(DateTime)
    interview_date = Column(DateTime)
    read_count = Column(Integer, default=0)
    create_time = Column(DateTime, default=func.now())
    status = Column(Integer, default=1)
    # 审核状态(0:待处理 1:通过 2:不适合)
    # 默认通过
    audit_status = Column(Integer, default=1)
    audit_msg = Column(String)
    audit_time = Column(DateTime)
    audit_userid = Column(Integer)
